Quản lý nhân sự công ty bằng c# _ full source code

60.454 lượt xem;
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 //using System.Data;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using System.IO;
13 //using Microsoft.SqlServer.Management.Common;
14
15 //using Microsoft.SqlServer.Management.Smo ;
16 using System.Data.SqlClient;
17
18 //using Microsoft.SqlServer.Management.Smo;
19
20 namespace QuanLyNhanSu
21 {
22     public partial class frmConfig : Telerik.WinControls.RadForm
23     {
24         QuanLyNhanSu.Class.readFile c = new QuanLyNhanSu.Class.readFile();
25         QuanLyNhanSu.Class.sql sql = new QuanLyNhanSu.Class.sql();
26
27         static public string server = "";
28         static public string data = "";
29
30         public SqlConnection con;
31         
32         public static frmConfig me;
33         public frmConfig()
34         {
35             me = this;
36             InitializeComponent();
37             try
38             {
39                 SqlConnection sc = new SqlConnection("Data Source =DATNGO\\SQLEXPRESS;Initial Catalog = master;Integrated Security=True;");
40                 sc.Open();
41                 SqlCommand scmd = new SqlCommand("select * from sysservers", sc);
42                 SqlDataReader sdr = scmd.ExecuteReader();
43                 if (sdr.HasRows)
44                 {
45                     while (sdr.Read())
46                     {
47                         RadComboBoxItem cmbi = new RadComboBoxItem();
48                         cmbi.Value = sdr.GetValue(2).ToString().Trim();
49                         cmbi.Text = sdr.GetValue(2).ToString().Trim();
50                         cmbServer.Items.Add(cmbi);
51
52
53
54                     }
55
56                 }
57                 RadComboBoxItem cmbi1 = new RadComboBoxItem();
58                 cmbi1.Text = "Window Authentication";
59                 cmbi1.Value = ".";
60                 cmbServer.Items.Add(cmbi1);
61
62                 sc.Close();
63             }
64             catch
65             {
66             }
67             this.cmbServer.SelectedIndex = 0;
68                         
69         }
70         public void khoitao(string servername, string database, string usernamesa, string passsa)
71         {
72             string sqlcon = "";
73             string sqlcon1 = "";
74             if (usernamesa.Trim() != String.Empty && passsa.Trim() != String.Empty)
75             {
76                sqlcon = "server =" + servername + " ; database = " + database +
77                     "; uid = " + usernamesa + "; pwd =" + passsa;
78                sqlcon1 = "server =" + servername + " ; database = master" +
79                     "; uid = " + usernamesa + "; pwd =" + passsa;
80             }
81             else
82             {
83                 sqlcon = "Data Source =" + servername + " ; Initial Catalog = " + database +
84                    ";Integrated Security=True ";
85                 sqlcon1 = "Data Source =" + servername + " ; Initial Catalog = master" +
86                     ";Integrated Security=True";
87             }
88             server = servername;
89             data = database;
90             SqlConnection sc = new SqlConnection(sqlcon);
91             SqlConnection sc1 = new SqlConnection(sqlcon);
92             SqlConnection sc2 = new SqlConnection(sqlcon1);
93             
94             FileInfo file = new FileInfo(Application.StartupPath + "\\File\\script1.sql");
95             string script = file.OpenText().ReadToEnd();
96             
97             //Server servers = new Server(new ServerConnection(sc));
98             //servers.ConnectionContext.ExecuteNonQuery(script);
99             sc.Close();
100
101             
102             sc2.Open();
103             SqlCommand scmd0u0 = new SqlCommand("KiemTraLogin", sc2);
104             SqlParameter ulogu0 = new SqlParameter("@loginname", "u0");
105             scmd0u0.CommandType = CommandType.StoredProcedure;
106             scmd0u0.Parameters.AddRange(new SqlParameter[] { ulogu0 });
107             object o1u0 = scmd0u0.ExecuteScalar();
108             sc2.Close();
109             if (o1u0 == null)
110             {
111                 sc1.Open();
112                 SqlCommand scmd2u0 = new SqlCommand("KiemTraUser", sc1);
113                 SqlParameter uu0 = new SqlParameter("@username", "u0");
114                 scmd2u0.CommandType = CommandType.StoredProcedure;
115                 scmd2u0.Parameters.AddRange(new SqlParameter[] { uu0 });
116                 object ou0 = scmd2u0.ExecuteScalar();
117                 sc1.Close();
118                 if (ou0 != null)
119                 {
120                     sc1.Open();
121                     SqlCommand scmd3u0 = new SqlCommand("Dropuser", sc1);
122                     SqlParameter nameu0 = new SqlParameter("@username", "u0");
123                     scmd3u0.CommandType = CommandType.StoredProcedure;
124                     scmd3u0.Parameters.AddRange(new SqlParameter[] { nameu0 });
125                     scmd3u0.ExecuteNonQuery();
126                     sc1.Close();
127                 }
128                 sc1.Open();
129                 SqlCommand scmd1u0 = new SqlCommand("AddLogIn", sc1);
130                 SqlParameter maloginu0 = new SqlParameter("@name", "u0");
131                 SqlParameter passloginu0 = new SqlParameter("@pass", "123");
132                 scmd1u0.CommandType = CommandType.StoredProcedure;
133                 scmd1u0.Parameters.AddRange(new SqlParameter[] { maloginu0, passloginu0 });
134                 scmd1u0.ExecuteNonQuery();
135                 sc1.Close();
136
137                 sc1.Open();
138                 SqlCommand scmd4u0 = new SqlCommand("AddUser", sc1);
139                 SqlParameter loginnameu0 = new SqlParameter("@loginname", "u0");
140                 SqlParameter usernameu0 = new SqlParameter("@username", "u0");
141                 scmd4u0.CommandType = CommandType.StoredProcedure;
142                 scmd4u0.Parameters.AddRange(new SqlParameter[] { loginnameu0, usernameu0 });
143                 scmd4u0.ExecuteNonQuery();
144                 sc1.Close();
145             }
146             else
147             {
148                 sc1.Open();
149                 SqlCommand scmd2u0 = new SqlCommand("KiemTraUser", sc1);
150                 SqlParameter uu0 = new SqlParameter("@username", "u0");
151                 scmd2u0.CommandType = CommandType.StoredProcedure;
152                 scmd2u0.Parameters.AddRange(new SqlParameter[] { uu0 });
153                 object ou0 = scmd2u0.ExecuteScalar();
154                 sc1.Close();
155                 if (ou0 != null)
156                 {
157                     sc1.Open();
158                     SqlCommand scmd3u0 = new SqlCommand("Dropuser", sc1);
159                     SqlParameter nameu0 = new SqlParameter("@username", "u0");
160                     scmd3u0.CommandType = CommandType.StoredProcedure;
161                     scmd3u0.Parameters.AddRange(new SqlParameter[] { nameu0 });
162                     scmd3u0.ExecuteNonQuery();
163                     sc1.Close();
164
165
166
167                 }
168                 sc1.Open();
169                 SqlCommand scmd4u0 = new SqlCommand("AddUser", sc1);
170                 SqlParameter loginnameu0 = new SqlParameter("@loginname", "u0");
171                 SqlParameter usernameu0 = new SqlParameter("@username", "u0");
172                 scmd4u0.CommandType = CommandType.StoredProcedure;
173                 scmd4u0.Parameters.AddRange(new SqlParameter[] { loginnameu0, usernameu0 });
174                 scmd4u0.ExecuteNonQuery();
175                 sc1.Close();
176
177
178             }
179
180
181             //kiem tra trong bang user va tao
182             sc.Open();
183             string sqluser = "select * from tbl_user";
184             SqlCommand scmd = new SqlCommand(sqluser, sc);
185             SqlDataReader sdr = scmd.ExecuteReader();
186
187             while (sdr.Read())
188             {
189                 string ma = sdr.GetString(0).Trim();
190                 string pass = sdr.GetString(1).Trim();
191                 string grp = sdr.GetString(2).Trim();
192
193                 sc2.Open();
194                 SqlCommand scmd0 = new SqlCommand("KiemTraLogin", sc2);
195                 SqlParameter ulog = new SqlParameter("@loginname", ma);
196                 scmd0.CommandType = CommandType.StoredProcedure;
197                 scmd0.Parameters.AddRange(new SqlParameter[] { ulog });
198                 object o1 = scmd0.ExecuteScalar();
199                 sc2.Close();
200                 if (o1 == null)
201                 {
202                     sc1.Open();
203                     SqlCommand scmd2 = new SqlCommand("KiemTraUser", sc1);
204                     SqlParameter u = new SqlParameter("@username", ma);
205                     scmd2.CommandType = CommandType.StoredProcedure;
206                     scmd2.Parameters.AddRange(new SqlParameter[] { u });
207                     object o = scmd2.ExecuteScalar();
208                     sc1.Close();
209                     if (o != null)
210                     {
211                         sc1.Open();
212                         SqlCommand scmd3 = new SqlCommand("Dropuser", sc1);
213                         SqlParameter name = new SqlParameter("@username", ma);
214                         scmd3.CommandType = CommandType.StoredProcedure;
215                         scmd3.Parameters.AddRange(new SqlParameter[] { name });
216                         scmd3.ExecuteNonQuery();
217                         sc1.Close();
218                     }
219                     sc1.Open();
220                     SqlCommand scmd1 = new SqlCommand("AddLogIn", sc1);
221                     SqlParameter malogin = new SqlParameter("@name", ma);
222                     SqlParameter passlogin = new SqlParameter("@pass", pass);
223                     scmd1.CommandType = CommandType.StoredProcedure;
224                     scmd1.Parameters.AddRange(new SqlParameter[] { malogin, passlogin });
225                     scmd1.ExecuteNonQuery();
226                     sc1.Close();
227                     sc1.Open();
228                     SqlCommand scmd4 = new SqlCommand("AddUser", sc1);
229                     SqlParameter loginname = new SqlParameter("@loginname", ma);
230                     SqlParameter username = new SqlParameter("@username", ma);
231                     scmd4.CommandType = CommandType.StoredProcedure;
232                     scmd4.Parameters.AddRange(new SqlParameter[] { loginname, username });
233                     scmd4.ExecuteNonQuery();
234                     sc1.Close();
235                 }
236                 else
237                 {
238                     sc1.Open();
239                     SqlCommand scmd2 = new SqlCommand("KiemTraUser", sc1);
240                     SqlParameter u = new SqlParameter("@username", ma);
241                     scmd2.CommandType = CommandType.StoredProcedure;
242                     scmd2.Parameters.AddRange(new SqlParameter[] { u });
243                     object o = scmd2.ExecuteScalar();
244                     sc1.Close();
245                     if (o != null)
246                     {
247                         sc1.Open();
248                         SqlCommand scmd3 = new SqlCommand("Dropuser", sc1);
249                         SqlParameter name = new SqlParameter("@username", ma);
250                         scmd3.CommandType = CommandType.StoredProcedure;
251                         scmd3.Parameters.AddRange(new SqlParameter[] { name });
252                         scmd3.ExecuteNonQuery();
253                         sc1.Close();
254
255                     }
256
257                     sc1.Open();
258                     SqlCommand scmd5 = new SqlCommand("Droplogin", sc1);
259                     SqlParameter ma_login = new SqlParameter("@loginname", ma);
260                     scmd5.CommandType = CommandType.StoredProcedure;
261                     scmd5.Parameters.AddRange(new SqlParameter[] { ma_login });
262                     scmd5.ExecuteNonQuery();
263                     sc1.Close();
264                     sc1.Open();
265
266                     SqlCommand scmd1 = new SqlCommand("AddLogIn", sc1);
267                     SqlParameter malogin = new SqlParameter("@name", ma);
268                     SqlParameter passlogin = new SqlParameter("@pass", pass);
269                     scmd1.CommandType = CommandType.StoredProcedure;
270                     scmd1.Parameters.AddRange(new SqlParameter[] { malogin, passlogin });
271                     scmd1.ExecuteNonQuery();
272                     sc1.Close();
273                     sc1.Open();
274
275                     SqlCommand scmd4 = new SqlCommand("AddUser", sc1);
276                     SqlParameter loginname1 = new SqlParameter("@loginname", ma);
277                     SqlParameter username = new SqlParameter("@username", ma);
278                     scmd4.CommandType = CommandType.StoredProcedure;
279                     scmd4.Parameters.AddRange(new SqlParameter[] { loginname1, username });
280                     scmd4.ExecuteNonQuery();
281                     sc1.Close();
282
283                 }
284
285                 if (ma != "administrator")
286                 {
287                     sc1.Open();
288                     SqlCommand scmd5 = new SqlCommand("AddRolesMember", sc1);
289                     SqlParameter rolename = new SqlParameter("@rolesname", grp);
290                     SqlParameter uname = new SqlParameter("@username", ma);
291                     scmd5.CommandType = CommandType.StoredProcedure;
292                     scmd5.Parameters.AddRange(new SqlParameter[] { rolename, uname });
293                     scmd5.ExecuteNonQuery();
294                     sc1.Close();
295                 }
296                 else
297                 {
298                     sc1.Open();
299                     SqlCommand scmd6 = new SqlCommand("AddVip", sc1);
300                     SqlParameter useradmin = new SqlParameter("@useradmin", ma);
301                     SqlParameter role = new SqlParameter("@rolename", grp);
302                     scmd6.CommandType = CommandType.StoredProcedure;
303                     scmd6.Parameters.AddRange(new SqlParameter[] { useradmin, role });
304                     scmd6.ExecuteNonQuery();
305                     sc1.Close();
306                 }
307             }
308             sc.Close();
309
310         }
311
312         private void frmConfig_Load(object sender, EventArgs e)
313         {
314             this.cmbDatabase.Items.Clear();
315             //if (this.txtUserName.Text != String.Empty && this.txtPassword.Text != String.Empty)
316             //{
317             
318                 c.readfile();
319                 string strDatabase = "";
320                 if (c.strLine1.Contains("Server:") == true) cmbServer.SelectedValue = c.strLine1.Substring(7);
321                 if (c.strLine2.Contains("Database:") == true) strDatabase = c.strLine2.Substring(9);
322                 if (c.strLine3.Contains("Username:") == true) txtUserName.Text = c.strLine3.Substring(9);
323                 if (c.strLine4.Contains("Password:") == true) txtPassword.Text = c.strLine4.Substring(9);
324
325
326                 if (txtUserName.Text.Trim() != String.Empty && txtPassword.Text.Trim() != String.Empty)
327                 {
328
329                     try
330                     {
331                         con = new SqlConnection("Data Source='" + cmbServer.SelectedValue.ToString() + "';Initial Catalog='" + strDatabase + "';User ID='" + txtUserName.Text + "';Password='" + txtPassword.Text + "'");
332
333                         con.Open();
334
335                         SqlCommand scmd = new SqlCommand("select * from tbl_NhanVien", con);
336                         scmd.ExecuteNonQuery();
337                         khoitao(cmbServer.SelectedValue.ToString(), strDatabase, txtUserName.Text, txtPassword.Text);
338
339                         frmDangNhap obj = new frmDangNhap();
340                         obj.ShowDialog();
341                         this.Close();
342                         con.Close();
343
344
345
346                     }
347                     catch (Exception ex)
348                     {
349                         //RadMessageBox.Show("\nĐường dẫn kết nối không đúng ! \nVui lòng xem lại !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
350                     }
351                 }
352                 else if (txtUserName.Text.Trim() == String.Empty && txtPassword.Text.Trim() == String.Empty)
353                 {
354                     try
355                     {
356                         con = new SqlConnection("Data Source='" + cmbServer.SelectedValue.ToString() + "';Initial Catalog='" + strDatabase + "';Integrated Security=True");
357
358                         con.Open();
359
360                         SqlCommand scmd = new SqlCommand("select * from tbl_NhanVien", con);
361                         scmd.ExecuteNonQuery();
362                         khoitao(cmbServer.SelectedValue.ToString(), strDatabase, "", "");
363                         frmDangNhap obj = new frmDangNhap();
364                         obj.ShowDialog();
365                         this.Close();
366                         con.Close();
367
368
369
370                     }
371                     catch (Exception ex)
372                     {
373                         //RadMessageBox.Show("\nĐường dẫn kết nối không đúng ! \nVui lòng xem lại !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
374                     }
375                 }
376                 else
377                 {
378
379
380                     //RadMessageBox.Show("\nĐường dẫn kết nối không đúng ! \nVui lòng xem lại !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
381
382                 }
383             
384             
385
386         }
387
388         private void btnCancel_Click(object sender, EventArgs e)
389         {
390             Application.Exit();
391         }
392
393         private void btnOK_Click(object sender, EventArgs e)
394         {
395             
396             if (this.txtUserName.Text != String.Empty && this.txtPassword.Text != String.Empty)
397             {
398                 try
399                 {
400                     khoitao(cmbServer.SelectedValue.ToString(), this.cmbDatabase.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim());
401                     con = new SqlConnection("Data Source='" + cmbServer.SelectedValue.ToString() + "';Initial Catalog='" + this.cmbDatabase.Text + "';User ID='" + txtUserName.Text + "';Password='" + txtPassword.Text + "'");
402                     con.Open();
403
404                     c.writefile(cmbServer.SelectedValue.ToString(), this.cmbDatabase.Text.Trim(), this.txtUserName.Text.Trim(), this.txtPassword.Text.Trim());
405
406
407
408
409                     frmDangNhap obj = new frmDangNhap();
410                     obj.ShowDialog();
411                     this.Close();
412                     con.Close();
413
414
415
416                 }
417                 catch (Exception ex)
418                 {
419                     RadMessageBox.Show("\nĐường dẫn kết nối không đúng !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
420                     MessageBox.Show(ex.ToString());
421                 }
422             }
423             else
424             {
425                 try
426                 {
427                     khoitao(cmbServer.SelectedValue.ToString(), this.cmbDatabase.Text.Trim(), "", "");
428                     con = new SqlConnection("Data Source='" + cmbServer.SelectedValue.ToString() + "';Initial Catalog='" + this.cmbDatabase.Text + "';Integrated Security=True");
429                     con.Open();
430
431                     c.writefile(cmbServer.SelectedValue.ToString(), this.cmbDatabase.Text.Trim(), this.txtUserName.Text.Trim(), this.txtPassword.Text.Trim());
432
433
434
435
436                     frmDangNhap obj = new frmDangNhap();
437                     obj.ShowDialog();
438                     this.Close();
439                     con.Close();
440
441
442
443                 }
444                 catch (Exception ex)
445                 {
446                     RadMessageBox.Show("\nĐường dẫn kết nối không đúng !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
447                     MessageBox.Show(ex.ToString());
448                 }
449             }
450             
451         }
452
453         private void cmbDatabase_Click(object sender, EventArgs e)
454         {
455             this.cmbDatabase.Items.Clear();
456             if (this.txtUserName.Text != String.Empty && this.txtPassword.Text != String.Empty)
457             {
458                 try
459                 {
460                     con = new SqlConnection("Data Source='" + cmbServer.SelectedValue.ToString() + "';Initial Catalog=master;User ID='" + txtUserName.Text + "';Password='" + txtPassword.Text + "'");
461                     sql.LoadDataToCombobox(this.cmbDatabase, "select * from sys.databases", 0, con);
462
463                 }
464                 catch (Exception ex)
465                 {
466                     RadMessageBox.Show("\nĐường dẫn kết nối không đúng !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
467                 }
468             }
469             else if (this.txtUserName.Text == String.Empty && this.txtPassword.Text == String.Empty)
470             {
471                 try
472                 {
473                     con = new SqlConnection("Data Source='" + cmbServer.SelectedValue.ToString() + "';Initial Catalog=master;Integrated Security=True");
474                     sql.LoadDataToCombobox(this.cmbDatabase, "select * from sys.databases", 0, con);
475
476                 }
477                 catch (Exception ex)
478                 {
479                     RadMessageBox.Show("\nĐường dẫn kết nối không đúng !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
480                 }
481             }
482             else
483             {
484                 RadMessageBox.Show("\nĐường dẫn kết nối không đúng !\n", "Thông báo", MessageBoxButtons.OKCancel, RadMessageIcon.Exclamation);
485             }
486             
487         }
488
489         private void cmbServer_SelectedIndexChanged(object sender, EventArgs e)
490         {
491            
492             
493             if(this.cmbServer.SelectedItem!=null)
494             {
495                 if (this.cmbServer.SelectedIndex == 1)
496                 {
497                     this.txtUserName.Enabled = false;
498                     this.txtPassword.Enabled = false;
499                     this.txtUserName.Text = "";
500                     this.txtPassword.Text = "";
501                 }
502                 else
503                 {
504                     this.txtUserName.Enabled = true;
505                     txtUserName.Text="sa";
506                     this.txtPassword.Enabled = true;
507                     txtPassword.Focus();
508                 }
509             }
510            
511         }
512
513         
514
515        
516         
517     }
518 }



Quản lý nhân sự công ty bằng c# _ full source code 60.454 lượt xem

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

93 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

99 lượt xem

Đếm nguyên âm và phụ âm

135 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

211 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

168 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

185 lượt xem